package com.zhouyilin.bigevent2.mapper;


import com.zhouyilin.bigevent2.pojo.Category;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface CategoryMapper {
//      新增
    @Insert("insert into category(category_name , category_alias, create_user , create_time,update_time)" +
            "values(#{categoryName} , #{categoryAlias} ,#{createUser} ,#{createTime},#{updateTime}  )")
    void add(Category category);

//      查询分类
    @Select("select * from category where create_user = #{id}")
    List<Category> list(Integer id);
//      查询分类详情
    @Select("select * from category where id = #{id}")
    Category findById(Integer id);
//      更新分类信息
    @Update("update category set category_name = #{categoryName} , category_alias  = #{categoryAlias} , update_time = now() where id = #{id}")
    void update(Integer id, String categoryName, String categoryAlias);
//      删除分类
    @Delete("delete from category where id = #{id}")
    void deleteById(Integer id);
}
